package cn.edu.tsinghua.cic.ccss.bo;

import java.util.List;

import org.apache.poi.ss.usermodel.Workbook;
import org.forten.core.ro.DtoResultWithPageInfo;

import cn.edu.tsinghua.cic.ccss.dto.CourseStatisticsDto;
import cn.edu.tsinghua.cic.ccss.dto.CourseStatisticsDto4Export;
import cn.edu.tsinghua.cic.ccss.dto.CourseTotalStatisticsDto;
import cn.edu.tsinghua.cic.ccss.qo.CourseStatisticsQo;

public interface CourseStatisticsBo {
	/**
	 * 通过Qo查询课程统计信息
	 * */
	DtoResultWithPageInfo<CourseStatisticsDto> queryCourseStatisticsByQo(CourseStatisticsQo qo,int page);
	/**
	 * 查询统计信息
	 * */
	CourseTotalStatisticsDto queryCourseTotalStatistics(CourseStatisticsQo qo);
	/**
	 * 导出excel,获取数据源
	 * */
	List<CourseStatisticsDto4Export> export(CourseStatisticsQo qo);
	
	/**
	 * 往导出excel中插入总计数据
	 * */
	void insertTotalNumsIntoExcel(Workbook wb,CourseTotalStatisticsDto totalDto);
}
